﻿<!--//=============================================================
    // Copyright (C) 2015 福流网络
    // 作 者：钟星星
    // 日 期：2016-01-15
    // 描 述:  结算调账自定义查询
    // 版 本：1.00
    // 修改历史纪录
    // 版 本  修改时间      修改人            修改内容
    //=============================================================-->
<div id="QueryItem">

    <table style="width: 100%;">
        <tr>
            <td style="width: 100%;">
                <div>
                    <div class="col1" id="query_item_company_name">
                        <table class="query_table">
                            <tr>
                                <td class="label">所属公司</td>
                                <td class="exp" style="display: none">
                                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                                </td>
                                <td>
                                    <select style="width:100%; margin-left: 4px;" name="company_name" class="mini-combobox">
                                        <option value=""></option>
                                        <option value="华报报关公司">华报报关公司</option>
                                        <option value="华物报关公司">华物报关公司</option>
                                    </select>

                                </td>
                            </tr>
                        </table>
                    </div>


                    <div class="col1" id="query_item_bill_name">
                        <table class="query_table">
                            <tr>
                                <td class="label">单号类型</td>
                                <td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td>
                                <td>
                                    <select style="width:100%; margin-left: 4px;" id="bill_name" name="bill_name" class="mini-combobox" multiselect="true">
                                        <option value=""></option>
                                        <option value="报关费">报关费</option>
                                        <option value="保安费">保安费</option>
                                        <option value="港建费">港建费</option>
                                        <!--<option value="保安费-港建费">保安费-港建费</option>
                                        <option value="报关费-保安费-港建费">报关费-保安费-港建费</option>-->
                                    </select>

                                </td>
                            </tr>
                        </table>
                    </div>

                    <div class="col1" id="query_item_payee_status_names">
                        <table class="query_table">
                            <tr>
                                <td class="label">收款状态</td>
                                <td class="exp" style="display: none">
                                    <select>
                                        <option value="=">等于</option>
                                        <option value=">">大于</option>
                                        <option value="<">小于</option>
                                        <option value="between">在..之间</option>
                                    </select>
                                </td>
                                <td>
                                    <select style="width:100%; margin-left: 4px;" name="payee_status_names" showclose="true" multiselect="true" class="mini-combobox" oncloseclick="onCloseClick">
                                        <option value=""></option>
                                        <option value="未收款">未收款</option>
                                        <option value="挂账未收款">挂账未收款</option>
                                        <option value="收款中">收款中</option>
                                        <option value="已收款">已收款</option>
                                    </select>

                                </td>
                            </tr>
                        </table>
                    </div>


                    <div class="col1" id="query_item_arp_type_name">
                        <table class="query_table">
                            <tr>
                                <td class="label">收款方式</td>
                                <td class="exp" style="display: none">
                                    <select>
                                        <option value="=">等于</option>
                                        <option value=">">大于</option>
                                        <option value="<">小于</option>
                                        <option value="between">在..之间</option>
                                    </select>
                                </td>
                                <td>
                                    <select style="width:100%; margin-left: 4px;" id="arp_type_name" name="arp_type_name" class="mini-combobox">
                                        <option value=""></option>
                                        <option value="挂账">挂账</option>
                                        <option value="现金">现金</option>
                                        <option value="转账">转账</option>
                                    </select>
                                </td>
                            </tr>
                        </table>
                    </div>
                    

               
                    

                    <div class="col1" id="query_item_reconciliation_no"><table class="query_table"><tr><td class="label">对账单号</td><td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td><td><input name="reconciliation_no" class="mini-textbox" style="width:100%;" data="reconciliation_no_data" /></td></tr></table></div>
                  

                    <div class="col1" id="query_item_jsy_name">
                        <table class="query_table">
                            <tr>
                                <td class="label">计费员</td>
                                <td class="exp" style="display: none">
                                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                                </td>
                                <td>
                                    <div id="jsy_name" name="jsy_name" class="mini-combobox" style="width:100%;float: left;" popupwidth="250" textfield="name" valuefield="name"
                                         showclose="true" valuefromselect="true" url="../../../Share/GetJsonList?tablename=v_fin_jfy_name&fieldnames=name&searchField=name" oncloseclick="onCloseClick">
                                    </div>

                                </td>
                            </tr>
                        </table>
                    </div>
                    
                    
                    <!--<div class="col1" id="query_item_transport_name">
                        <table class="query_table">
                            <tr>
                                <td class="label">所属部门</td>
                                <td class="exp" style="display: none">
                                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                                </td>
                                <td>
                                    <select style="width:100%; margin-left: 4px;" name="transport_name" multiselect="true" class="mini-combobox">
                                        <option value=""></option>
                                        <option value="海运部">海运部</option>
                                        <option value="陆运部">陆运部</option>
                                        <option value="空运部">空运部</option>
                                        <option value="关务部">关务部</option>
                                    </select>

                                </td>
                            </tr>
                        </table>
                    </div>-->

                    <div class="col1" id="query_item_transport_id">
                        <table class="query_table">
                            <tr>
                                <td class="label">组织机构</td>
                                <td class="exp" style="display: none">
                                    <select>
                                        <option value="=">等于</option>
                                        <option value="like">包含</option>
                                        <option value=" not like">不包含</option>
                                        <option value="<>">不等于</option>
                                    </select>
                                </td>
                                <td>
                                    <input id="transport_id" name="transport_id" isexpandednode="true" shownullitem="true" style="width: 100%" multiselect="true" popupwidth="200" popupmaxheight="400" showfoldercheckbox="true" expandonload="true" selectonfocus="true"
                                           checkrecursive="true" class="mini-treeselect" url="/extendpage/action/dataaction.aspx?action=dept&functionid=93de9757-a95e-49cd-9b70-a827d1484868&paraCondtion=isbussiness_dept=1 and dept_type=2"
                                           textfield="name" valuefield="id" parentfield="parent_id" />
                                </td>
                            </tr>
                        </table>
                    </div>

                    
                    

                    <div class="col1" id="">
                        <table class="query_table">
                            <tr>
                                <td class="label">会计期间</td>
                                <td>
                                    <div id="period_name" name="period_name" class="mini-autocomplete" style="width:100%" popupwidth="500" allowinput="true" textfield="periodEndDt" valuefield="id" value="0" onvaluechanged="commentValueChanged"
                                         showclose="true" valuefromselect="true" url="../../../Share/GetJsonList?tablename=t_fin_account_period&fieldnames=id,period_name,period_begin_dt,period_end_dt,( CONVERT(varchar(100),period_begin_dt ,23) + %2B + '/' + %2B +  CONVERT(varchar(100),period_end_dt,23) ) as periodEndDt&searchField=period_name" oncloseclick="onCloseClick">
                                        <div property="columns">
                                            <div header="简称" field="period_name"></div>
                                            <div header="开始时间" field="period_begin_dt"></div>
                                            <div header="结束时间" field="period_end_dt"></div>
                                        </div>
                                    </div>
                                </td>
                            </tr>
                        </table>
                    </div>

                    <div id="query_item_kjqj_dt" style="display:none">
                        <table class="query_table">
                            <tr>
                                <td>
                                    <input id="txtaudit_dt_1" name="audit_dt_1" class="mini-hidden" style="width:100%;" data="audit_dt_data" />
                                    <input id="txtaudit_dt_2" name="audit_dt_2" class="mini-hidden" style="width:100%;" data="audit_dt_data" />
                                </td>

                            </tr>
                        </table>
                    </div>

                    
                    <div class="col1" id="query_item_operator">
                        <table class="query_table">
                            <tr>
                                <td class="label">结算员</td>
                                <td class="exp" style="display: none">
                                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                                </td>
                                <td>
                                    <div id="operator" name="operator" class="mini-combobox" style="width:100%;float: left;" popupwidth="250" textfield="name" valuefield="name"
                                         showclose="true" valuefromselect="true" url="../../../Share/GetJsonList?tablename=v_fin_userinfo&fieldnames=name&where=type=2&searchField=name" oncloseclick="onCloseClick">
                                    </div>

                                </td>
                            </tr>
                        </table>
                    </div>
                    
                    <div class="col1" id="query_item_bill_no">
                        <table class="query_table">
                            <tr>
                                <td class="label">结算单号</td>
                                <td class="exp" style="display: none">
                                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                                </td>
                                <td>
                                    <div id="bill_no" name="bill_no" class="mini-autocomplete" style="width:100%;" popupwidth="250" textfield="bill_no" valuefield="bill_no" valuefromselect="true" oncloseclick="onCloseClick" pinyinfield="bill_no"
                                         showclose="true" url="../../../Share/GetJsonList?tablename=t_arps&fieldnames=bill_no&searchField=bill_no">
                                        <div property="columns">
                                            <div header="简称" field="bill_no"></div>
                                        </div>
                                    </div>
                                </td>
                            </tr>
                        </table>
                    </div>



                    
                    <div class="col1" id="query_item_payee_name">
                        <table class="query_table">
                            <tr>
                                <td class="label">收款人</td>
                                <td class="exp" style="display: none">
                                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                                </td>
                                <td>
                                    <div id="payee_name" name="payee_name" class="mini-combobox" style="width:100%;float: left;" popupwidth="250" textfield="name" valuefield="name"
                                         showclose="true" valuefromselect="true" url="../../../Share/GetJsonList?tablename=v_fin_payee&fieldnames=name&searchField=name" oncloseclick="onCloseClick">
                                    </div>

                                </td>
                            </tr>
                        </table>
                    </div>
                    

                    <div class="col2" id="query_item_payee_dt">
                        <table class="query_table">
                            <tr>
                                <td class="label">收款日期</td>
                                <td class="exp" style="display: none">
                                    <select>
                                        <option value="=">等于</option>
                                        <option value=">">大于</option>
                                        <option value="<">小于</option>
                                        <option value="between">在..之间</option>
                                    </select>
                                </td>
                                <td>
                                    <input name="payee_dt" class="mini-datepicker" style="width:100%;" data="payee_dt_data" />
                                </td>
                                <td>
                                    <input name="payee_dt_1" class="mini-datepicker" style="width:100%;" data="payee_dt_data" />
                                </td>
                            </tr>
                        </table>
                    </div>

                    <div class="col2" id="query_item_created_dt">
                        <table class="query_table">
                            <tr>
                                <td class="label">生成日期</td>
                                <td class="exp" style="display: none">
                                    <select>
                                        <option value="=">等于</option>
                                        <option value=">">大于</option>
                                        <option value="<">小于</option>
                                        <option value="between">在..之间</option>
                                    </select>
                                </td>
                                <td>
                                    <input name="created_dt" class="mini-datepicker" style="width:100%;" data="created_dt_data" />
                                </td>
                                <td>
                                    <input name="created_dt_1" class="mini-datepicker" style="width:100%;" data="created_dt_data" />
                                </td>
                            </tr>
                        </table>
                    </div>
                    
                    
                    <div class="col2" id="query_item_apply_dt">
                        <table class="query_table">
                            <tr>
                                <td class="label">报关截至日</td>
                                <td class="exp" style="display: none">
                                    <select>
                                        <option value="=">等于</option>
                                        <option value=">">大于</option>
                                        <option value="<">小于</option>
                                        <option value="between">在..之间</option>
                                    </select>
                                </td>
                                <td>
                                    <input name="apply_dt" class="mini-datepicker" style="width:100%;" data="apply_dt_data" />
                                </td>
                                <td>
                                    <input name="apply_dt_1" class="mini-datepicker" style="width:100%;" data="apply_dt_data" />
                                </td>
                            </tr>
                        </table>
                    </div>
                    
                    
                    <div class="col1" id="query_item_customer_name">
                        <table class="query_table">
                            <tr>
                                <td class="label">客户</td>
                                <td class="exp" style="display: none">
                                    <select>
                                        <option value="=">等于</option>
                                        <option value=">">大于</option>
                                        <option value="<">小于</option>
                                        <option value="between">在..之间</option>
                                    </select>
                                </td>
                                <td>
                                    <div id="customer_name" name="customer_name" class="mini-autocomplete" style="width:100%;float: left;" popupwidth="400" allowinput="true" textfield="short" valuefield="short"
                                         showclose="true" valuefromselect="true" url="../../../Share/GetJsonList?tablename=t_base_objs&fieldnames=id,zucode,short&where=zclass_id=100 and stop_yn=0&searchField=short,zucode" oncloseclick="onCloseClick">
                                        <div property="columns">
                                            <div header="id" field="id" width="0"></div>
                                            <div header="编号" field="zucode"></div>
                                            <div header="简称" field="short"></div>
                                        </div>
                                    </div>
                                </td>
                            </tr>
                        </table>
                    </div>
                    
                    
                    <div class="col2" id="query_item_use_no">
                        <table class="query_table">
                            <tr>
                                <td class="label">自编号</td>
                                <td class="exp" style="display: none">
                                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                                </td>
                                <td>
                                    <input name="use_no" class="mini-textbox" style="width:100%;" data="use_no_data" />
                                </td>
                                <td>
                                    <input name="use_no_1" class="mini-textbox" style="width:100%;" data="use_no_data" />
                                </td>
                            </tr>
                        </table>
                    </div>



                </div>
            </td>
        </tr>

    </table>
</div>

<script type="text/javascript">
    function commentValueChanged(e) {
        if (e.value != "") {
            var beginDt = e.selecteds[0].period_begin_dt;
            var endDt = e.selecteds[0].period_end_dt;
            mini.get("txtaudit_dt_1").setValue(beginDt);
            mini.get("txtaudit_dt_2").setValue(endDt);
        } else {
            mini.get("txtaudit_dt_1").setValue("");
            mini.get("txtaudit_dt_2").setValue("");

        }
    }
</script>